package pers.xx.sbm.dao;

import org.springframework.stereotype.Repository;
import pers.xx.sbm.vo.TotalSampleVo;

import java.util.List;
import java.util.Map;

@Repository
public interface DyReportDataMapper {

    List<TotalSampleVo> queryTotalScore(int currentYear, String areaName, String schoolName, String xd);

    List<Integer> selectNumbers();

    List<String> query1IndexNamesByXd(String xd);

    double queryScoreByXdAndIndexName(String xd, String indexName, int year);

    List<Double> queryTotalScoreHistory(int currentYear, String areaName, String schoolName, String xd);

    List<Double> queryIndexTotalScoreHistory(int currentYear, String areaName, String schoolName, String xd, String indexName);

    List<TotalSampleVo> query2IndexScoreByXd(String xd, String indexName, int year);

    List<String> query2IndexNameByXd(String xd, int year);

    List<String> query2IndexNamesByXd(String xd);

    List<Double> query2IndexScoreHistory(int currentYear, String areaName, String schoolName, String xd, String indexName);
}
